|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
6
   |
Posted - 2017.03.11 23:36:53 -
[1] - Quote
Hi all,
This is a first alpha version of a phpBB extension that enables Single sign on for registration and login to the phpBB forum software: Downloads
Current features:
- phpBB auth provider (replaces regular login completely)
- Login / Registration using EVE accounts
- Group management based on corp / alliance (using ESI to fetch)
- Teamspeak serverGroup management based on corp / alliance
Installation and setup:
This extension is under development, if you install it on anything but a fresh and empty board, backup your database and files now.
- Upload the contents of the zip to your forum root (the zip should already contain the directory structure /ext/snitch/authevesso)
- Go to the ACP
- Enable the extension under 'Customise', if it doesnt show up check the directory structure.
- Go to developers.eveonline.com and create an App, select API access the scope esi-corporations.read_corporation_membership.v1, set the callback url to server/forumurl/authevesso/login
- Go to you forum ACP: General - Client communication - Authentication
- Enter your app id and secret you got in the above step, as well as the Admin character name (Important: This has to be an eve character you will use from now on to log in as admin. If this char already exists as a board user, make him a founder and grant all permissions now.)
- Save Settings
- Change authentication method to Evesso and save.
- Log in with the admin EVE char and purge the forum cache in the ACP.
- Start adding Groups / Teamspeak groups under 'Extensions'
if something goes wrong and you locked yourself out, access your database and find the key auth_method in your phpbb_config table and change it from 'evesso' to 'db'.
To do:
- Implement logging
- Testing
- Better session management (when logging in from multiple devices)
- ???
A few notes how its working:
This extension automatically creates a forum user account for evey user that logs in with his eve account.
It only handles the groups configured in the extensions ACP menu, it will not add OR REMOVE from any of the groups / teamspeak groups not entered there.
phpBB3.1+ has a new cron system. if you wish to run the cron jobs manually, the command to do so is: php _install_dir_/bin/phpbbcli.php cron:run (set to run e.g. once in 15 minutes, dont worry, the actual jobs run at different intervals) In that case, go to your boards server settings and set 'run periodic tasks from system...' to 'yes'.
Credits:
Inspired by phpBB 3.1 Authentication Provider for Shibboleth
Using the Teamspeak PHP framework
ESI client generated using swagger codegen
Happy testing,
Report any bugs you ancounter here or to [email protected]
If you wanna support this project, feel free to throw some ISK at Snitch Ashor
o7, Snitch |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
6
|
Posted - 2017.03.12 07:16:14 -
[2] - Quote
Reserved. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
8
|
Posted - 2017.03.17 21:04:44 -
[3] - Quote
Milo Caman wrote:Super happy to see this again, but seeing this when I try to log into my fresh forum after setting up: SQL ERROR [ mysqli ]
Unknown column 'session_authstate' in 'field list' [1054]
Don't have access to my database from work, so will reset the auth method and have a closer look when I get home in a few hours, but if there's any quick fixes to this that'd be excellent.
Hmmm weird, that column should have been installed with the mod. Will try it myself on a fresh install. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
8
|
Posted - 2017.03.17 21:57:25 -
[4] - Quote
That is related to the first I guess, looks like the migration that installs database tables and columns is not executed at all in your case, will try to figure out what went wrong. If you want to retry you have to deinstall the mod and delte all data of the mod in the customization tab |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.18 00:19:35 -
[5] - Quote
Thanks for reporting back, could you do one more quick check just look if the file
_phpBBinstall_/phpbb/db/migration/migration.php is present and tell me what php version you are running please?
Thanks.
Btw since all migrations require that class, the one that creates the profile field to enter the teamspeakID might be missing as well. You can just create it under users-> custom profile fields:
Identifier: authevesso_tsid Type: single text field.
Publicly display profile field: NO and the only options that should be ticked are:
Display in user control panel
Hide profile field |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.18 06:47:01 -
[6] - Quote
Yeah you are right. You can disable board registration yourself for now in the ACP. I will either disable the button or just forward registration to the sso as well. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.18 19:03:12 -
[7] - Quote
Paic Aishai wrote:Thanks man. Cool project you're working on here !
I also tried to install this and ran into the same problems as Milo. After following your instructions, the extension page is now accesible and database schemas seems ok, but when I try to login, I get an "Invalid auth state." error.
The auth state seems to be passed along correctly during the OAuth process, it is even set correctly in the database (phpbb_sessions.session_authstate)
Any ideas ?
So basically what is supposed to happen is the auth state, which is just a random number is stored in the session sb before sending the user to the sso page and the response is compared afterwards. Not sure what goes wrong there. Could you post or pm me your forum address? |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.18 19:07:03 -
[8] - Quote
Felicity Stihl wrote:Cool project
I installed it without a hitch, but when I enable authentication, I will get a 404 error when trying to hit the login button.
The 404 is for forums.domain.tld/authevesso/login (my phpbb install is not in a subdirectory)
Any ideas on this one ?
Will have to try and reproduce it. If you feel like trying it on a subfolder, let me know if it works. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.19 13:20:47 -
[9] - Quote
Felicity Stihl wrote:Quick update:
Made a new VM to test this on, completley vanilla ubuntu 16.10 , just installed mod_php, apache2, phpmyadmin, and mysql. installed a fresh version of phpbb 3.2 and added your plugin, so far so good..
after installing, and activating the plugin, I cannot access the /authevesso/login url (http://172.16.32.149/phpbb/authevesso/login?target=http%3A%2F%2F172.16.32.149%2Fphpbb%2Findex.php)
Thanks for testing, will do the same, the only difference to my test enviroment is ubuntu16.10 and prly the mysql version. Will let you know if i can figure out what it is. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.19 19:51:15 -
[10] - Quote
Felicity Stihl wrote:
To anwser my own post:
Found two issues,
1. had to explictly set the php variable "register_globals" to off
2. had to install php-curl (which is not mentioned as a requirement anywhere)
Seems to work now, except for the fact that when I log in, I get a error complaning about "INSECURE_REDIRECT".. (things still work if I refresh)
Thanks a lot.
Indeed php5.5+ with curl is a requirement for the API client library, added that to the opening post and readme.
I'm abit confused about the other part since register_globals = OFF should be default since php 4.x and phpBB itself should complain if its on...
The INSECURE_REDIRECT, is that a phpBB error message and when does it appear?
I uploaded a version 1.0.1 (Download Link in the opening post) which should fix the problem about databases not being created on install.
@Felicity Stihl could you try this commit that should fix your insecure redirect warnings. |
|
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.20 23:04:22 -
[11] - Quote
Yeah I know about the persistent login problem, its on the todo list. Right now I try to use phpbbs builtin remember me function, but it still fails most of the time, need to do some diggin there. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.23 13:10:18 -
[12] - Quote
Paic Aishai wrote:Small issue here too : it seems that when the EveSSO auth method is selected, some part of the board (home page, like "who is online" , statistics ; few strings in UCP/ACP ; ...) are not in the default board language.
When I switched back to Db auth method everything was ok.
I also tried to reinstall the language but it did not change anything. Can it may come from the extension ?
Definetly a bug of the extension thanks, should be fixed in v1.0.2.
Btw. the mod is not yet translated but programmed in a way so it should be easy to translate. If someone is in the mood to do a translation, let me know, its only about 30 lines of text, mostly related to the ACP. In phpBB, mods will always fallback to english if the right translation is not available, but this only works if english is not deinstalled.
Bests,
Snitch |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.23 13:15:45 -
[13] - Quote
Felicity Stihl wrote:I did however notice an odd thing with the original build, I have phpbb's timeouts set to several days, but the user session will time out within less than an hour, and require relogging, is that by design, and/or can I change the timeouts somewhere , or is this something that the new commit may have fixed ? (Just applied it, so I'll know within a few hours)
EDIT: Seems like the timeout issues are fixed, my sessions even persisted between reboots...
EDIT2: Scratch that, times out after an hour..
I tried a lot of things regarding this but I'm still not entirely sure why logouts sometimes occur after an hour and most of the time (at least for me) not in days. I posted some more details here:
https://bitbucket.org/snitchashor/php-ext-authevesso/issues/1/user-sessions-timing-out-inconsistently
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.24 13:41:40 -
[14] - Quote
Paic Aishai wrote:
Updated to v1.0.2a, all good. Thanks for the quick fix man !
Thats also what I thought but 1.0.2 breaks a part of the ACP, fixed here: 1.0.3a In this one language and ACP should be working.
Also anyone running 1.0.0 and having issues with logouts occuring very often, please update and let me know if it got better. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.25 15:45:45 -
[15] - Quote
Pohwaran wrote:Hey,
I installed everything like said, had a few problems with the callback url but got that sorted. Now I'm stuck at "Error: Invalid auth state." The DB is set to evesso, I made sure of that. Any help would be appreciated.
Thanks.
Edit - I fixed it turns out it was something to do with the way the database was set up. I was using MySQL with the extension, when my web host didn't use the extenion, change the database type, reinstalled the forum + the EVE SSO and it works like a charm
Glad it works now. Could you tell me what you changed to get around the database issue? |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.26 20:43:00 -
[16] - Quote
Pohwaran wrote:
It goes back all the way back to the core installation of the forum itself, on the second page after setting up an admin user it asks for the database, I was installing the forum with MySQL with MySQLi Extension as the database type, using this type of database the Evesso would spit the error of invalid auth state. I then went and reinstalled the whole forum under the normal MySQL database, installed the plugin again and it worked like it should, and has been working fine since I fixed the database type.
Overall it's a great plugin, can't wait to see what else you add to it.
I have to admit this should not be the case and Mysqli should be used. I will try to reproduce that error. As for features, somebody already requested to see corp and alliance next to peoples names, I think thats a nice gimmick.
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
9
|
Posted - 2017.03.30 10:07:48 -
[17] - Quote
Updated version (1.0.6a). Lots of changes and a russian translation (thanks to Jintaro Keo). Disable the mod during the update and purge cache afterwards. I also added the general update procedure to the opening post. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
10
|
Posted - 2017.03.31 19:24:01 -
[18] - Quote
Milo Caman wrote:When attempting to update, I'm getting the following message when trying to re-enable the extension:
General Error
SQL ERROR [ mysqli ]
Duplicate column name 'user_refreshToken' [1060]
SQL
ALTER TABLE `phpbb_users` ADD COLUMN `user_refreshToken` varchar(255) NULL
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1061
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1269
CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 549
CALL: phpbb\db\tools\tools->sql_column_add()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php
LINE: 185
CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
Any ideas? EDIT: Attempts to install the latest version on a completely fresh install of phpbb yields the following when trying to enable the extension: General Error
SQL ERROR [ mysqli ]
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [1171]
SQL
CREATE TABLE phpbb_authevesso_membership ( characterID bigint(20) NULL, corporationID bigint(20) NULL, corporationName varchar(100) NULL, allianceID bigint(20) NULL, allianceName varchar(100) NULL, PRIMARY KEY (characterID) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1061
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 444
CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 489
CALL: phpbb\db\tools\tools->sql_create_table()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php
LINE: 185
CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
Should be fixed in this one: https://bitbucket.org/snitchashor/php-ext-authevesso/get/42c27894557b.zip
Any chance you can tell me your mysql version?
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
10
|
Posted - 2017.03.31 20:02:29 -
[19] - Quote
Milo Caman wrote:It's now throwing the error about the duplicate column again.
I'm running on mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64). Hope this helps?
Can you delete the columns? I think i got the migrations right now, but with previous versions this might be an issue. Also clearing the extensions data should remove the columns |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
10
|
Posted - 2017.03.31 20:14:03 -
[20] - Quote
https://bitbucket.org/snitchashor/php-ext-authevesso/get/44c15b1fc830.zip should fix it...
This fix should only be required for mysql >= 5.6 for all others v1.0.6a should be fine |
|
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
10
|
Posted - 2017.03.31 20:40:38 -
[21] - Quote
This is due to a fix I added for people without mod rewrite. The mod nowbtells in the authentication settings what the callback should be. In your case, since you obviously have mod rewrite, go to acp -> general -> server config -> server and domain and enable url rewriting, clear the cache and it should be working. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
10
|
Posted - 2017.04.01 05:47:18 -
[22] - Quote
Syenna Celeste wrote:Milo Caman wrote:[
EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled. Fixed (we think). Line 115 login.php. Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().' /app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state; New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;
Thanks, did overlook that. So you can use that change for now, or change the callback at the eve dev page. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
11
|
Posted - 2017.04.03 21:54:11 -
[23] - Quote
Milo Caman wrote:Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks  Still not seeing the extensions tab though. Were some functions moved elsewhere?
I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
11
|
Posted - 2017.04.04 19:34:10 -
[24] - Quote
Milo Caman wrote:Snitch Ashor wrote:Milo Caman wrote:Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Still not seeing the extensions tab though. Were some functions moved elsewhere? I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce. Hrm. Would running the query from before fix this? Is it even possible to do the migrations manually via the cli or mysql?
Sorry no. There are three migrations, one does database stuff, one installs the acp module and one inserts the teamspeak profile field. Can you check if the last one is there? |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
11
|
Posted - 2017.04.05 22:06:43 -
[25] - Quote
Milo Caman wrote:Installed migrations listed as per CLI output are:
* \snitch\authevesso\migrations\add_table_100
* \snitch\authevesso\migrations\version_104
* \snitch\authevesso\migrations\version_101
* \snitch\authevesso\migrations\profilefield_tsid_100
* \snitch\authevesso\migrations\add_module_100
The output from the query is as follows:
Database changed
mysql> SELECT * FROM `phpbb_migrations` WHERE `migration_name` LIKE '%snitch%';
+-----------------------------------------------------+-----------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------+--
---------------------+---------------------+----------------------+----------------------+--------------------+
| migration_name | migration_depends_on
| m
igration_schema_done | migration_data_done | migration_data_state | migration_start_time | migration_end_time |
+-----------------------------------------------------+-----------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------+--
---------------------+---------------------+----------------------+----------------------+--------------------+
| \snitch\authevesso\migrations\add_module_100 | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";}
|
1 | 1 | | 1490953922 | 1490953923 |
| \snitch\authevesso\migrations\add_table | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";}
|
1 | 1 | | 0 | 0 |
| \snitch\authevesso\migrations\add_table_100 | a:1:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";}
|
1 | 1 | | 1490953923 | 1490966569 |
| \snitch\authevesso\migrations\profilefield_tsid | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types"
;} |
1 | 1 | | 1489791031 | 1489791031 |
| \snitch\authevesso\migrations\profilefield_tsid_100 | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types"
;} |
1 | 1 | | 0 | 0 |
| \snitch\authevesso\migrations\version_101 | a:3:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";i:1
;s:43:"\snitch\authevesso\migrations\add_table_100";i:2;s:51:"\snitch\authevesso\migrations\profilefield_tsid_100";} |
1 | ...
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
11
|
Posted - 2017.04.05 23:14:13 -
[26] - Quote
Milo Caman wrote:Doesn't look like it's a permissions issue, a regular admin doesn't see the extensions tab either.
How would I go about removing the add_module_100 migrations row? With the mod disabled db:list no longer shows the migrations as installed or available. Would it be worth deleting the extension's data again or might this just cause further problems?
That might work as well but i would just delete the table row first, e.g. using phpmyadmin if you have, if not, its
DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\' |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
11
|
Posted - 2017.04.05 23:47:01 -
[27] - Quote
Milo Caman wrote:mysql does not like this query at all and makes a big fuss about the backslash characters, should it just be something like: DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = '\snitch\authevesso\migrations\add_module_100'; instead? EDIT: The exact output is: mysql> DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'
ERROR:
Unknown command '\''.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\''.
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'' at line 1
DELETE FROM phpbb_migrations WHERE migration_name = '\snitch\authevesso\migrations\add_module_100'; should do.
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
17
|
Posted - 2017.04.08 19:45:24 -
[28] - Quote
Milo Caman wrote:New day, new problem! Looks like the groups_check.php cronjob isn't being run by the system. I don't seem to be able to run it manually either as it returns the below: Class 'phpbb\cron\task\base' not found in /var/www/html/forum/ext/snitch/authevesso/cron/groups_check.php on line 20 I'm going to go out on a limb and assume that this is migration-related, but I'm not really sure how phpbb handles it's internal crons. I had a poke around, but I'm feeling a bit lost in it all. Any ideas?
No for once this has nothing to do with the migrations. Looks like its unable to find the cron base class which is part of phpbb. How did you try to run the cron job manually? It requires the phpbb enviroment so if you want to run it manually, try php path_to_forum/bin/phpbbcli.php cron:run task.groups_check and let me know if that works. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
17
|
Posted - 2017.04.09 13:27:53 -
[29] - Quote
Milo Caman wrote:When I tried to run it manually, I just navigated to /ext/snitch/authevesso/cron and ran the script with php. Trying to run the task from cli gives me the following:
php bin/phpbbcli.php cron:run cron.task.groups_check
[RuntimeException]
Could not find cron task GÇ£cron.task.groups_checkGÇ¥.
Can you please post the output of
php bin/phpbbcli.php cron:list
If groups_check shows up as ready to be run please run
php bin/phpbbcli.php cron:run
Which runs all crons and then list again to check if groups moved to the not ready Section. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
22
|
Posted - 2017.04.13 20:45:02 -
[30] - Quote
Milo Caman wrote:The output of cron:list is:
Ready tasks:
============
* cron.task.core.tidy_cache
* cron.task.core.tidy_search
* cron.task.core.tidy_sessions
* cron.task.core.tidy_warnings
Not ready tasks:
================
* cron.task.core.prune_all_forums
* cron.task.core.prune_forum
* cron.task.core.prune_shadow_topics
* cron.task.core.prune_notifications
* cron.task.core.queue
* cron.task.core.tidy_database
* cron.task.core.tidy_plupload
* cron.task.text_reparser.pm_text
* cron.task.text_reparser.poll_option
* cron.task.text_reparser.poll_title
* cron.task.text_reparser.post_text
* cron.task.text_reparser.user_signature
After running cron:run, everything is moved to the 'Not ready' section. I assume that the groups.check task should be included in this list?
Hmmm the cron job is missing completely. I'm kinda lost here. May I ask you to do a clean phpbb3.2 install in parralel and try the latest version? You still have some leftovers of the first version which may or may not be the issue |
|
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
22
|
Posted - 2017.04.14 10:35:37 -
[31] - Quote
Morg Yard wrote: All works fine, but we have multiple forum founders, and one of them cant login to forum with following error: Quote:Username already exists but is not linked to an EVE account Character linking with already created account is enabled in ACP->Extention config Please help us to resolve this issue. 
This is a security feature, linking existing accounts that have extended permissions (like admin or founder) is not working, because people might have user accounts like admin or administrator and there are actually eve characters named like this. The one exception is the admin user that you explicitly specify, so here's what you can do:
Change the admin user in the authentication settings to the one you want to link, heave him log in, repeat with the next founder.
Sorry I'm not gonna change this behaviour as this would introduce a huge security hole.
Bests,
Snitch |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
23
|
Posted - 2017.04.29 18:28:16 -
[32] - Quote
Norian Lonark wrote:Snitch Ashor wrote:Syenna Celeste wrote:Milo Caman wrote:[
EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled. Fixed (we think). Line 115 login.php. Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().' /app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state; New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state; Thanks, did overlook that. So you can use that change for now, or change the callback at the eve dev page. EDIT: Just pushed a fix here: https://bitbucket.org/snitchashor/php-ext-authevesso/downloads/php-ext-authevesso-v1.0.7a.zip
In order not to get locked out. If you had used version <= 1.0.5 and it worked, got to ACP -> General -> Server Confg. -> Server and domain and enable url rewriting. After that continue normal: disable the extension, update files, clear chache, reenable Firstly thank you very much for working on this great mod. I just wanted to check with you but I downloaded the latest version but still have this issue of the rewrite not looking like its working. I corrected it by manually changing the callback on the development page and adding the /app.php/ to the beginning of the path after my forum url. Just wondered if you had any ideas?
Just to make sure...
You enabled rewriting in the ACP right? And at the acp page where you enter your dev key, what callback url is given there?
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
23
|
Posted - 2017.05.23 08:19:44 -
[33] - Quote
Norian Lonark wrote:Hi Snitch, is there anyway with this that you can use the phpbb authentication for other services. I really want to be able to use dokuwiki or mediawiki for our wiki solution. Currently we use temars plugin for SMF and its quite easy to then authenticate the wiki against the smf database so the user can use the same username and password. With this plugin it seems that the user doesn't actually get a password or anything on the forum? or can they set one on their forum profile and the SSO will still work. Basically I am just looking for a way that a user could authenticate against the forums and also use the forum account for the WIKI. sorry if this is off topic I am not wanting to hijack or take time.. but am searching for a straight forward solution and I may be missing something simple and obvious due to my own limitations of understanding these technical things 
in principle this can be done. I did a quick search and found this: https://www.mediawiki.org/wiki/Extension:PHPBB/Users_Integration
might work.
Cheers,
Snitch |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
23
|
Posted - 2017.05.23 08:24:38 -
[34] - Quote
Dan Conia wrote:Hello, all. I seem to be getting an extra ":80" in my callback URL. Note just after the ".com". This results in the "The callback URI doesn't match the value stored for this client" error. https://login.eveonline.com/oauth/authorize/?response_type=code&redirect_uri=https%3A%2F%2Ftaggarttransdimensional.com%3A80%2Fphpbb%2Fapp.php%2Fauthevesso%2Flogin I thought I would be clever and try adding it to the callback in the EVE Developers site, but then nothing else works. If I try manually editing the browser call it works without an issue. Does anybody know where this ":80" is coming from? Great extension otherwise. I'm hoping I can contribute in some way (including the wiki question!). Thanks.
Hi,
to be honest i am not sure how the port ended up there since it's a standard one. Are you using https over port 80?
Could you double check you got the following settings in you phpbb ACP under Server config/Server settings:
Server protocol: https://
Server port: 443
if this is already the case could you please try:
Force server URL settings: yes
Bests,
Snitch |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
23
|
Posted - 2017.05.29 14:21:39 -
[35] - Quote
Dan Conia wrote:Norian Lonark wrote:Hi Snitch, thanks for the check I will have a go at installing it and see what happens when using it in combination with your mod. Nori. Nori, I noticed an extension that piggybacks on the login of the phpBB. You then just go to your wiki site and it checks phpBB to see if you're a current login. Extension:PHPBB/Users IntegrationEdit: Wow, I got so hung up on SSO, I didn't realize you had already posted THE EXACT SAME THING. LOL MOAR COFFEE!!!
No problem, as my time to code/play is limitd tjese days, any help is appreciated.
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
23
|
Posted - 2017.06.08 13:24:19 -
[36] - Quote
Changed links and description in the OP. Changed version number to 1.1b. I hope in the following weeks I find the time for a few new features I got requests for. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
24
|
Posted - 2017.07.19 14:39:34 -
[37] - Quote
Norio Nori wrote:FlexiusVII wrote:
What do you mean by saying it did not work, exactly? I've done the same thing (independently) and it's kinda fixed my issue (logging in from different IPs causing logout).
The consistency of sid and cookie values in sessions table became illegal. (An error occurs when trying to log out explicitly.) In my environment, sessions table is periodically deleted by cron task. (cron.task.core.tidy_sessions) In pure phpBB, even if the value of sessions table disappears, the value left in sessions_keys table and Auto login is possible using cookie_k and cookie_u left in the browser, but in SSO environment I felt that sessions table does not work well because there are additional columns. However, since I am not familiar with programming, please let me know if there is a good idea! 
Thanks that helped a lot, persistent logins are hopefully working in this version: https://bitbucket.org/snitchashor/php-ext-authevesso/get/490a9a6a8117.zip
please let me know. However after the session is cleared, you will have to authenticate for the admin login but within the board you should stay logged in. I'm pretending this is a security feature, but infact the admin state does not seem to be resored via cookie login since its part of the session and I guess theres nothing I can do about it.
|
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
25
|
Posted - 2017.07.22 19:32:31 -
[38] - Quote
Mapster Tacitus wrote:First of all: Thank you for this peace of software.
Installation and all went well.
Teamspeak is an issue now. When does the Script apply the groups ? The Server Query login seems to work since it pulls the ts3 server groups correctly from the server and i can assign them to corps/alliances in the extension tab.
With a fresh board user entering their unique id in their profile, the script seems to do nothing yet.
EDIT: i got one step further. once a user entered their unique ID and clicks send, HTTP Error 500, but the teamspeak server correctly assigns the group. after pushing F5 the profile site didnt saved the id in the field.
TS groups are assigned at two points, first when the user enters the ID and afterwards every time the cron job runs and the groups would change. Any chance you can get me an apache log of that 500 error? Will try to reproduce it anyway. |
Snitch Ashor
Black Rise Guerilla Forces
The Bloc
25
|
Posted - 2017.07.30 13:35:08 -
[39] - Quote
Mapster Tacitus wrote:Sure 23.07.2017 16:08:36 [client 2003:c9:2300::] PHP Fatal error: Uncaught exception 'TeamSpeak3_Adapter_ServerQuery_Exception' with message 'duplicate entry' in /ext/snitch/authevesso/libraries/TeamSpeak3/Adapter/ServerQuery/Reply.php:319, referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] Stack trace:, referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] #0 /ext/snitch/authevesso/libraries/TeamSpeak3/Adapter/ServerQuery/Reply.php(91): TeamSpeak3_Adapter_ServerQuery_Reply->fetchError(Object(TeamSpeak3_Helper_String)), referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] #1 /ext/snitch/authevesso/libraries/TeamSpeak3/Adapter/ServerQuery.php(141): TeamSpeak3_Adapter_ServerQuery_Reply->__construct(Array, 'servergroupaddc...', Object(TeamSpeak3_Node_Host), true), referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] #2 /ext/snitch/authevesso/libraries/TeamSpeak3/Node/Abstract.php(73): TeamSpeak3_Adapter_ServerQuery->request('servergroupaddc...', true), referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] #3 /ext/snitch/authevesso/libraries/TeamSpeak3/Node/Server.php(90): TeamSpeak3_Node_Abstract->request('servergroupaddc...', true), referer: /ucp.php?i=178
23.07.2017 16:08:36 [client 2003:c9:2300::] #4 /mnt/web307/b2/25/542347 in /ext/snitch/authevesso/libraries/TeamSpeak3/Adapter/ServerQuery/Reply.php on line 319, referer: /ucp.php?i=178
Does that user already have groups on your ts server? I'm wondering if the mod tries to add a user that already exists, even though on my server that does not seem to be a problem...
|
|
|
| |
|